Release 10.1A: OpenEdge Development:
Programming Interfaces

Order of fetched records

The FOR EACH statement, OPEN QUERY statement, and PRESELECT option may use multiple indexes to satisfy a query. When multiple indexes are used, the order of returned records is not guaranteed. You can enforce an order by using the BY option.

The following example returns the selected customer records in ascending credit–limit order and within credit limit in name order:

FOR EACH customer BY Credit-limit BY Name: